In [1]:
import pandas as pd
import plotly.express as px

start_row = 0  # Include the header row
end_row = 94  # Include the last row of the dataset

# Assuming you have an Excel file named 'data.xlsx' with a sheet named 'sunburst_data'
df = pd.read_excel('Sunburst_20231206.xlsx', sheet_name='sunburst_data', nrows=end_row, skiprows=start_row)

fig = px.sunburst(df, path=['Domain', 'Need', 'Service'], values='Percentage',
                  title='Interactive Sunburst Chart',
                  width=800, height=800
                  )


fig.show()
In [2]:
 

Domain                               Evaluation
Need          Reflecting on future improvements
Service                                     NaN
Percentage                                  1.0
Name: 93, dtype: object
In [3]:
 

Domain        NaN
Need          NaN
Service       NaN
Percentage    NaN
Name: 94, dtype: object
In [ ]: